USE master
go
if exists (select * from sys.databases where name = 'MarketDB')
	drop database MarketDB
go
create database MarketDB
on primary
(
	name = 'MarketDB_Data',
	filename = 'E:\MarketDB_Data.mdf',
	size = 5mb,
	filegrowth = 10%
)
log on
(
	name = 'MarketDB_Log',
	filename = 'E:\MarketDB_Log.ldf',
	size = 5mb,
	filegrowth = 10%
)
go
use MarketDB
go
create table UserInfo
(
	UserNo int primary key not null,
	UserPass varchar(100) not null,
	UserName nvarchar(20) not null
)

insert into UserInfo(UserNo,UserName,UserPass) values(1,'abc','abc')
insert into UserInfo(UserNo,UserName,UserPass) values(2,'123','123')
insert into UserInfo(UserNo,UserName,UserPass) values(3,'Admin','admin')
